﻿CREATE ROLE [FileAdmin] AUTHORIZATION dbo;
GO
GRANT EXECUTE ON [dbo].[fnIO_DirectoryExists] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[fnIO_DirectoryName] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[fnIO_Extension] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[fnIO_FileExists] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_CopyFile] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_CreateDirectory] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_DeleteDirectory] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_DeleteFile] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_GetVolumeSpace] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_MoveDirectory] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_MoveFile] TO [FileAdmin];
GO
GRANT EXECUTE ON [dbo].[spIO_WriteFile] TO [FileAdmin];
GO

GRANT SELECT ON [dbo].[fnIO_GetFiles] TO [FileAdmin];
GO
GRANT SELECT ON [dbo].[fnIO_GetSubdirectories] TO [FileAdmin];
GO
